﻿IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[se_SearchData]') AND type in (N'U'))
BEGIN
 CREATE TABLE [dbo].[se_SearchData](
	[ID] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
	[Url] [varchar](500) NULL,
	[Title] [varchar](500) NULL,
	[HtmlBodyText] [varchar](800) NULL,
	[inuse] [char](1) NULL,
 CONSTRAINT [PK_TSearchData] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[se_Url]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[se_Url](
	[ID] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
	[Url] [varchar](500) NULL,
	[Inuse] [char](1) NULL,
 CONSTRAINT [PK_TUrl] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END